update TEST_NOIDX set CREATETIME=now() where ID in ( select a.ID from TEST_NOIDX a where a.VNAME='Aa'); ERROR 1093 (HY000): You can't specify target table 'TEST_NOIDX' for update in FROM clause update TEST_NOI ...